Yes, It's possible to show certain collection like sub collections at the top of a collection Page. It require some customisation with HTML, CSS, JS and Liquid code. Also require to create some settings so you can manage collection and sub collection by own. share your store URL and theme name so I can assist you better.
Nick here from Shopify.
Great question and thanks for sharing the screesnhot, it was very helpful to figure out exactly what you're looking for. I reached out to our theme support team about this and they said it is definitely possible but also quite complex and would require a lot of customizations which would be out of the scope of a reply in the community here. Your best bet would be to reach out to a Shopify Expert or developer about having this implemented. You can see the Shopify Small Task Expert directory here. I know this might not be an exact answer to your question, but it is the best and most efficient way of getting this done if you are not comfortable with doing it yourself.
Hope this helps!
All the best, Nick