Dialogue

A: Could you tell me where Mr. John’s office?
A: Could you tell me where Mr. John’s office is?
Are both OK?

You need a verb with the clause beginning ‘where’ and so ‘is’ is required.