A Labour MP in England has apologised for a social media joke which sparked accusations that he was making light of prostitution.