A seven-year-old boy who was badly burned in a city street in Scotland has died in hospital, police said.