Describe the bug
From testing the new support for listing unpublished entries in collections with the editorial workflow from 7f8a371.

The unpublished entries are added to the bottom of the collection with no sorting, making the UI a bit unpredictable.

To Reproduce

1. Enable editorial workflow
2. Set up a collection with some existing entries and sorting fields
3. Create draft unpublished entries in the collection
4. View the collection

Expected behavior
The draft unpublished entries are sorted with the published entries according to the sort order, e.g. alphabetically by title:

Another draft new page 2 [DRAFT]
Another existing entry 2
Draft new page 1 [DRAFT]
Existing entry 1

Or for the unpublished entries to be listed below, but sorted the same way.

Actual behavior

Unpublished entries are always listed below existing entries and not following the sort order:

Another existing entry 2
Existing entry 1
Draft new page 1 [DRAFT]
Another draft new page 2 [DRAFT]

Screenshots
This collection shows the unpublished pages at the bottom of the list, but not following the sort order:

Applicable Versions:
Tested on main at 7f8a371.