The Scottish city has replaced Brighton as the highest-ranking city in the UK outside London for foreign direct investment attractiveness, a key survey reveals