sql: Enable locality optimized scans in the row engine

[jseldess]

Jesse Seldess (jseldess) commented:

PR: cockroachdb/cockroach#63384

From release notes:

Enabled locality-optimized search in the row execution engine. [#63384][#63384] {% comment %}doc{% endcomment %}

Jira Issue: DOC-1403