[docs] improve best-effort filter documentation

[vbarua]

The language around https://substrait.io/relations/logical_relations/#read-filtering could use a fuller example to make it clearer. It might be good to mention other optimizations that it can be used for, like file pruning when using an index to read columnar files.