Bug: WebPageRelatedItem ordering not preserved when using Content Item API with linked items

When retrieving a page using the Content Item API with ContentItemQueryBuilder and loading related pages via WithLinkedItems(), the order of related items does not match the order defined in the CMS UI (drag & drop order in relationship field).

The returned related items appear unordered (likely DB join order), and there is no exposed API to access relationship ordering metadata.

here is snap-shot of content saved in db

here the result what I am getting

  var builder = new ContentItemQueryBuilder()
  .ForContentType(ProductCategory.CONTENT_TYPE_NAME, config =>
  config.ForWebsite(_channelContext.GetWebsiteChannelName())
  .Where(where => where.WhereEquals(nameof(WebPageFields.WebPageItemID), context.WebPage.WebPageItemID))
  .WithLinkedItems(100, o => o.IncludeWebPageData())
  );
  var Result = await _contentQueryExecutor.GetMappedWebPageResult<ProductCategory>(builder);
  var page= Result.FirstOrDefault();

Environment

• Xperience by Kentico version: [30.8.1]

• .NET version: [8]

• Execution environment: [Local Dev ]

What is the recommended or supported approach in Xperience by Kentico to retrieve related items in the same order as defined in the CMS UI?