Improve parallel CSV scan

[2010YOUY01]

Is your feature request related to a problem or challenge?

This issue is to address the remaining tasks from an initial parallel CSV scan PR #6801

The remaining tasks:

1. Use get_opts() for range read on local FS
   get_opts() is an interface for range streaming read from ObjectStore (local FS/ cloud storage), currently it's not supported for range read on local FS https://github.com/apache/arrow-rs/blob/0d4e6a727f113f42d58650d2dbecab89b22d4e28/object_store/src/lib.rs#L355
   When it's implemented in arrow-rs, we can use it in parallel CSV scan implementation and possibly get some performance improvement (the current implementation will copy the whole CSV file range into memory at once instead of in a streaming fashion)
2. Use only 1 get operation from ObjectStore for each partition instead of 3 (see original PR discussion)

It's easier to do task 2 after 1 is done (can do tests on the local filesystem)

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response

[alamb]

Since the items on this enhancement are well understood I think it would be a good one for someone who wants to improve things in DataFusion to try

[parkma99]

I will take it.

I find apache/arrow-rs#4352 is tracked range read on local FS.

I would like to handle this after that Issue is closed.

[parkma99]

It was fixed by #7282. cc @alamb

[alamb]

Thanks for the ping @parkma99