MPs have rejected legislation that would have allowed cyclists on minor roads or cycle paths or people canoeing on the country’s rivers to have a small amount of alcohol in their blood.