A veteran London cop has resigned amid allegations he hired a sex-trade worker and insulted fellow officers on social media.