Southampton has been named the third most sober city in the UK.