Starkly contrasting fortunes for Scotland’s cities have been highlighted.