John Swinney looked set to miss his target of an SNP majority last night as voters rejected his divisive independence plans.