A torrent of water from three overflowing rivers has torn through a small city in Colombia while people slept, destroying homes, sweeping away cars and killing at least 193 residents.