A television advert for Southern Comfort has been banned by the UK's advertising watchdog for linking alcohol consumption to a successful evening.