End of the SNP predicted as Humza Yousaf’s party ‘will lose seats at the next UK election’