Fix S3 Seekable Reads with Parallel Read Buffer

Fix s3 seekable reads with parallel read buffer. (Affected memory usage during query). Closes #38258. #38802 (Kseniia Sumarokova).