The SNP are falling apart faster than the Union Nicola Sturgeon’s embattled administration is besieged within and without