A drunk holidaymaker had to be handcuffed to a chair during an eight-hour flight from Mexico back to Manchester Airport.