Improve match start from Scan in multiple pattern

[Shylock-Hg]

Introduction

In query MATCH (v0:player),(v1:team) RETURN v0,v1 LIMIT 100, we could push Limit over BiCartesianProduct to let it start from ScanVertices.
For query like MATCH (v0:player)-[:like]->(v2), (v2)-[:serve]->(v1:team) RETURN v0,v1 LIMIT 100, we can't push Limit over BiInnerJoin, so can't do this.

Contents

Related work

[czpmango]

Related to #5170.

[czpmango]

It is important to avoid the implementation of a feature that depends on optimizer, which is just a module responsible for performance optimization.