John Swinney is facing demands to drop his independence referendum push after he failed to secure the majority he said would be a mandate.