Table: scot_prem_clubs
Columns: club
town_or_city
total_seasons
total_spells
longest_spell
last_promotion
last_spl_season
years_absent
seasons
most_recent_finish
highest_finish

Question: What is the Highest finish with a Most recent finish that was 2nd?
SQL: SELECT "highest_finish" FROM scot_prem_clubs WHERE "most_recent_finish" = '2nd'