Engine optimize: optimize time expression based on time column index

**Is your feature request related to a problem? Please describe.**
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

### Example:
```SQL
SELECT t1.*, t2.* from t1
LAST JOIN t2 ORDER BY t2.std_ts
ON t1.id=t2.id and t2.std_ts BETWEEN timestamp("2021-01-01") and timestamp("2021-06-01");
```
We would like to optimize join with BETWEEN ... AND expression
**Describe the solution you'd like**
A clear and concise description of what you want to happen.

**Describe alternatives you've considered**
A clear and concise description of any alternative solutions or features you've considered.

**Additional context**
Add any other context or screenshots about the feature request here.