Is it possible to visit London during stopover of 4 to 6 hours. Do they grant a tourist visa at the airport ?

SG asked: I will be at London for 4 to 6 hours, waiting for connecting flight. Is it possible to make a brief visit to the city? Do authorities grant tourist visa at the airport ? OR can I have a tourist visa for such a short period at all, may be at UK embassy, [...]