Improve AND filter operator

Related issues: #9402, #8837

There are some improvements we want to do for AND filter operator:
- Avoid scanning the docs from the low selectivity filter when applying AND
- Skip using indexes when the selected docs are already very few. Using scan instead
- When applying bitmap to a scanned operator, push down the limit to avoid full scan (or evaluate lazily)