I wonder if it’s more because we frame the question by altering the structure to indicate the appropriate response.
We could just as well ask “you are from where?” Or “your name is what?” That matches the expected sentence structure of a response, and the natural pitch rises.
Was (not was) - Walk the dinosaur featured on the live action Flintstones movie.