Flynn who represents Aberdeen South in the House of Commons has rowed back on his plan to stand for Holyrood in 2026.