Excludes pre-release versions from `~latest` tag and shorthand fetching

What does this MR do and why?

Excludes pre-release versions from ~latest tag and from fetching with shorthand.

Changelog: changed

Screenshots or screen recordings

Assume there are two versions: 8.0.0-pre and 7.1.0

When requesting the ~latest version of a component:

prerelease should be excluded:

Before	After

When fetching a version via shorthand -

Before	After
	It won't find the version by shorthand: But it will find it if specified directly:

How to set up and validate locally

In a project marked as a catalog resource, create two versions if you don't have any:

1. First, create a minor or major version - 1.0.0
2. Then, create a higher version but mark it as prerelease - 2.0.0-pre - the "higher version" is just to test that it won't return the pre-release, even if it is technically a "latest" version

~latest should return the latest NON pre-release version - in this case 1.0.0

#460873 (closed)