Show latest changes in node "View" tab while using Content Moderation
Finally after spending huge amount of time on this, I am able to figure it out. Thanks to shawn-conn's answer here - Take over display of a content type node route
I have created a custom module and have added below files and code to achieve this,
First created mymodule.services.yml and added below code,
services:
  mymodule.route_subscriber:
    class: Drupal\mymodule\Routing\RouteSubscriber
    tags:
      - { name: event_subscriber }

Then created Routing folder under src.
Added file named RouteSubscriber.php with below code,
&lt;?php

namespace Drupal\mymodule\Routing;

use Drupal\Core\Routing\RouteSubscriberBase;
use Symfony\Component\Routing\RouteCollection;

/**
 * Listens to the dynamic route events.
 */
class RouteSubscriber extends RouteSubscriberBase {

  /**
   * {@inheritdoc}
   */
  public function alterRoutes(RouteCollection $collection) {

    // Alter the canonical node route to our custom route
    if ($route = $collection-&gt;get('entity.node.canonical')) {
      $route-&gt;setDefault('_controller', '\Drupal\mymodule\Controller\NodeRedirectController::view');
    }
  }
}

Then added NodeRedirectController.php under src/Controller directory with below code,
&lt;?php

namespace Drupal\mymodule\Controller;

use Drupal\Core\Entity\EntityInterface;
use Drupal\node\Controller\NodeViewController;


/**
 * Custom node redirect controller
 */
class NodeRedirectController extends NodeViewController {

  public function view(EntityInterface $node, $view_mode = 'full', $langcode = NULL) {
    // Display latest revision content in view mode
    if ($node-&gt;bundle() === 'my_content_type' &amp;&amp; $view_mode == 'full') {
      $vid = \Drupal::entityTypeManager()-&gt;getStorage('node')-&gt;getLatestRevisionId($node-&gt;id());
      $node_new = \Drupal::entityTypeManager()-&gt;getStorage('node')-&gt;loadRevision($vid);
      return parent::view($node_new, $view_mode, $langcode);
    }
    // Otherwise, display as per Drupal's default behaviour
    else {
      return parent::view($node, $view_mode, $langcode);
    }
  }
}

This might help someone.