A celebrity trying to keep his name out of a British tabloid “kiss-and-tell” story has won a supreme court fight with editors.