As a way of judging office prestige/competitiveness - within a given country there seems to be a correlation between prestige and the $$ cost per square unit of rental space. That makes NYC and SanFran highly competitive. I would not bank on a transfer but sure, it is also a possibility.
As an example, one guy I was very good friends with at Sloan went from Infrastructure to IB. This was 2008-10 so the market was a mess by the way. Anyway he was Italian and landed an internship at Deutsche Bank in London. Then the London team extended him a FT offer sometime after the summer. I guess there was technically a policy whereby if you got an offer you could request a different location. Like an idiot this guy thought NYC would be even more prestigious than London so requested the NYC office at the last minute - and the London team was like 'Uh err well ok'. The NYC bosses hated him (probably because they felt saddled with someone they didn't choose on a technicality).
He was among the first to go in subsequent layoffs.