Heartbreak for Scotland as SL clinch thriller to stay alive