The Scottish Conservatives and Scottish Labour have vowed to bring a vote of no confidence against MSP Angela Constance.