Drone footage shows massive damage from explosion in Scotland