Yousaf faces ‘bleak’ chances of surviving no confidence vote