The 31-day challenge poses a unique opportunity for Scots to ditch the booze and lean into sober curiosity - but some cities seem more keen on it than others