Scotland takes top three in ‘green’ UK major cities