The SNP pulls off one of the biggest upsets in election history