As the country’s main economic centre, London has commanded much of the Brexit spotlight, but recent research shows Manchester and Edinburgh performed strongly amid the uncertainty.