It’s only a matter of showing a Collection List limited to one single post. So you need something to filter the collection and have your post being the only result for the filter.
For example, if you want to show this post because it’s featured, then you can add a field in your collection. Chose a Switch field and set it up like this:
Then filter and limit your Collection list like this:
With that setup, you’ll be sure that your Collection List will only return 1 item, featured, and the most recent, in case there’s several.
Now, inside of your Collection list item, you’ll setup the link or link block like this:
To be clear, you need to add a Collection list to your frontpage to do this, you can’t just have the same result with a single link somewhere on the page. (You can have orphaned dynamic elements only on Collection Templates pages). However, you can place a Collection List wherever you want and only have a single text link inside of it, so it most likely can look the way you want it to look.