Edinburgh has been named the best city in Scotland for travelling to for a gig, and among the best in the UK, according to a new study.