To get the expected sort order, right-click in the bibliography and
Type tab which opens with dialog only defines the language for the sort.
Entries can be sorted on a variety of ways (author, title, year, …). The criteria are in the
Entries tab. By default, Sort by Document position is selected. Change for Content and tell Writer which Sort keys to use and sort direction (ascending or descending). Up to 3 keys can be specified.
The sort criteria can also be defined when the bibliography is initially created.
To show the community your question has been answered, click the ✓ next to the correct answer, and “upvote” by clicking on the ^ arrow of any helpful answers. These are the mechanisms for communicating the quality of the Q&A on this site. Thanks!
In case you need clarification, edit your question (not an answer) or comment the relevant answer.