The 'seventy weeks' prophecy in Daniel 9:24-27 is interpreted as a timeline leading to the Messiah. Beyond the specific duration, what theological significance does the prophecy hold regarding God's sovereignty over history and the purpose of Israel in God's plan?