A HGV operated by the Tesco supermarket chain has left a trail of destruction after careering off the road.