The gradual shift away from reliance on a single industry has helped the self-styled “energy capital of the world” take the top spot in the FT-Nikkei ranking of best US cities for foreign investment