Make kMaxPageSize adaptive

[Yuhta]

Description

Currently there is a threshold (10000) on limit to let partial limit query not buffering page data to accelerate these small queries. There is some attempt (#10909) to make this limit configurable. However after discussion, we think a better solution is to make kMaxPageSize adaptively increasing from a small number, so that no magic number needs to be configured in engine to accommodate both small limit and large streaming use cases.