Stephen Flynn, re-elected as an SNP MP in July, has announced plans to seek a Holyrood seat in 2026.