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