Answer was to apply below attribute: [EnableQuery(EnsureStableOrdering = false)]
https://learn.microsoft.com/en-us/dotnet/api/microsoft.aspnet.odata.enablequeryattribute.ensurestableordering?view=odata-aspnetcore-7.0