Psalm 110; 1 says, "The Lord says to my Lord; "Sit at my right hand until I make your enemies a footstool for your feet."
As king over Israel, David was the world's number one man, answerable only to God. This is the crux of the question.
How could David have a Lord between himself and God?
Literally what David was saying in Psalm 110; 1 was "The Lord says to my Lord", so David had a greater Lord, the Messiah, yet He is his son. We also read in the letter of St. Paul to the Roman's, 1; 3-5, "This news is about the Son of God who, according to the human nature He took, was a descendant of David; it is about Jesus Christ our Lord who in the order of the Spirit, the Spirit of Holiness that was in Him, was proclaimed Son of God in all His power through His resurrection from the dead." So David had a greater Lord, the Messiah, yet He is his son. As we look back with the benefit of the New Testament, we know exactly how this could happen. But the Lord Jesus used it to confound the Pharisees because He was the greater Son.
John 1; 1 says in the beginning was the Word and the Word with God and the Word was God. In the original Greek "Word" is "Logos" interpreted as "The power who master the universe," or the Mediator between God and Man. Yet in psalm 2; 7-9 says, “I will proclaim the decree of the Lord; He said to me, "You are my Son; today I have become your Father. Ask of me, and I will make the nations your inheritance, the ends of the earth your possession. You will rule them with an iron sceptre; you will dash them to pieces like pottery."
As we read earlier in the Gospel of St. John chapter 1, He was from all eternity and tabernacle among us and Pharisees has no concept of this when Jesus asked them on Matt22;42-45, "What do you (Pharisees) think about the Christ? Whose Son is He?" "The son of David," They replied.
He said to them, "How is it then that David, speaking by the Spirit, calls Him 'Lord'? For he says, "'The Lord said to my Lord; "Sit at my right hand until I put your enemies under your feet."' If then David calls Him 'Lord'. How can He be his son?"
The question is a real one for the Pharisees because they and Jesus are agreed not only that the Messiah will be described from David, but also that the Psalm is about the Messiah, and by David. We also find the same verses on the Acts 2; 34-35, where we read, "The Lord said to my Lord; sit at my right hand until I make your enemies a footstool for your feet."
We also see the same verses on Hebrew 1; 13.
Psalm110; 4 says, "You are a priest forever, in the order of Melchizedek." what we read on Genesis 14; 18, you are my chosen King but also 'You are my chosen Priest'.
Some did hold on this hope. Even when, centuries later, the royal line had long since disappeared from sight, there was always with in the nation a remnant waiting expectantly for the consolation of Israel, the redemption of Jerusalem and the kingdom of God; and when Jesus came such people recognized Him as the One who was to embody all this, the Christ.
The prophecy of Isaiah53 fulfilled. So Psalm 110 is a completely Prophetic Messianic Psalm. It contains no history, no historical counterpart, no typology or picture. In Psalm 110 only David's greater counterpart, Messiah, raised and ruling is in view.