I imagine that's one of the reasons they have "colos" - you can aim to collocate tables that are likely to be part of the same transaction in the same shard by putting them in the same colo group.

IIUC they never have db transactions across shards, because customers are basically data silos, which makes sharding quite straightforward.