A drunk passenger forced a holiday flight to be diverted when he became abusive after cabin crew refused to sell him more alcohol.