publishing an entry in a many relation within a component breaks ordering
### Node Version

20

### NPM/Yarn/PNPM Version

yarn 1

### Strapi Version

5.11.0

### Operating System

MacOS

### Database

SQLite

### Javascript or Typescript

Javascript

### Reproduction URL

https://github.com/laurenskling/strapi-5-tests/tree/feature/publish-relation-moves-to-the-end

### Bug Description

Publishing a selected relation (within a (DZ) component) will not show up in the API response.
Only when I reorder, it starts showing up in the result.
The order of the response does become out of sync with the admin UI. As if that (previously draft) item has a broken index number.

http://0.0.0.0:1337/api/articles/f10kfztylqyjrcsp9lvj3u4j?populate[blocks][on][shared.quote][populate][authors][fields]=*

### Steps to Reproduce

1. have a (DZ) component with a oneToMany relation
2. add relations with some draft items
3. publish that item
4. see that it does not show up in the API response
5. save and refresh because ordering newly selected relations is bugged....
6. move it in the relation ordering
7. see that it shows up, but at the incorrect order..

### Expected Behavior

relations always showing correctly in the correct order

### Logs

```shell

```

### Code Snippets

_No response_

### Media

https://github.com/user-attachments/assets/7a18068f-c90d-430c-b263-c6414af95521

### Additional information

related to 
https://github.com/strapi/strapi/pull/22834
https://github.com/strapi/strapi/issues/23155


### Confirmation Checklist

- [x] I have checked the existing [issues](https://github.com/strapi/strapi/issues) for duplicates.
- [x] I agree to follow this project's [Code of Conduct](https://github.com/strapi/strapi/blob/develop/CODE_OF_CONDUCT.md).