Dozens of people in northern Nigeria were killed in a massive explosion as they tried to scoop up fuel from a crashed tanker truck.