Publish a relation puts it at the end of the API output, not respecting order
### Node Version

20

### NPM/Yarn/PNPM Version

yarn 1

### Strapi Version

5.11.2

### 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

As discussed in https://github.com/strapi/strapi/pull/22834#issuecomment-2722396822, when I publish an entry that is selected as an relation, order is not respected.

https://github.com/user-attachments/assets/94818fc4-be29-43f3-88ba-4c02bffd833d

### Steps to Reproduce

1. create authors, some not published
2. create a article with these authors
3. publish an author that is not at the end
4. see that it shows up at the end in the API

### Expected Behavior

order respected

### Logs

```shell

```

### Code Snippets

_No response_

### Media

_No response_

### Additional information

related: https://github.com/strapi/strapi/pull/22834

### 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).