[Feature] Supports read-optimized via hints

### Search before asking

- [x] I searched in the [issues](https://github.com/apache/paimon/issues) and found nothing similar.

### Motivation

When need to improve query performance, one of the methods is to switch to read the `RO` table. However, when integrating other systems internally, it is found that the downstream system does not support switching tables, so hope that the query behavior can be changed through hint

### Solution

Add table option

### Anything else?

None

### Are you willing to submit a PR?

- [x] I'm willing to submit a PR!

No files, tests, or entry points are named in the issue. Start by locating how table options and query hints are handled, then clarify the intended option and verify that the hint changes reads to the RO table without requiring downstream table changes.

Written by the indexing model from the issue text.