An off-duty officer was knocked unconscious and had to be revived after a "despicable" brawl in a popular nightlife precinct.