Police say city worker heard a cry for help emanating from the truck and discovered the gruesome scene; Texas incident is among the deadliest in recent decades