Answer:
Not necessarily.
You can be between two people, so your position is in between them.
However, while you might say, "Between you and me, I think something is wrong", you would not say "In between you and me, I think something is wrong". These two statements would infer completely different meanings.