Scotland’s first minister faces motions of no confidence from Labour and the Conservatives after ending his power-sharing deal with the Green party