Sorting nodes by title aren't returned in correct order.
This PR includes latest changes from https://www.drupal.org/project/drupal/issues/3186834#comment-15425338 onwards
Additionally, fixed following things:
- Fixing test case failures.
- Fix the deprecation message formatting.
- Add the necessary trait for expectDeprecation methods.
- Add additional test case to validate the sort order when sort happens on non translatable field. This case was raised in comment #54
Closes #3186834