St Asaph is the most "sober-curious" city in the UK, according to new research.