Opposition MPs have lost critical vote on a bid to prevent a future Tory prime minister from forcing through a no-deal Brexit.