SNP story shattered after collapse leaves them with seats in single digits