What does the Bible say about the piercing of Messiah?

In Zechariah 13:7, the prophecy states, 'Awake, O sword, against the man that is my fellow, saith the Lord of hosts; smite the shepherd, and the sheep shall be scattered.' This indicates that the Messiah would be struck down, ultimately leading to the scattering of His flock. Jesus Himself alludes to this prophecy in Matthew 26:31, where He says that all His disciples will be offended because of Him on that very night. This piercing signifies the deep sorrow and suffering that would come upon the Messiah, fulfilling the redemptive plan foretold in the Old Testament.