For London is more usual
I would disagree. It may be dialectal, but I think "to London" sounds more natural.
If I were saying where is the train I would definitely say for. I would use to with going ie where is the train for London or where is the London train or is this train going to London
We are much more likely to say "for London" than "to London"
Where is the London train - more colloquial