Qwerty was designed to cut down on jams caused by adjacent typewriter arms, which generally were adjacent keys.

While not designed for best human use, it's not completely terrible.

Azerty vs Qwerty verus Qwertz is a different issue entirely.