arrow

GH-35710: [R] Followup improvements to new configure script (#36435)

### Rationale for this change

See #35710

### What changes are included in this PR?

* [Get `LIB_DIR` from `pkg-config` where possible](https://github.com/apache/arrow/pull/36435/commits/c8d09eb7c1077f580100b808a307f92afd17dd38), to handle the possibility that it is `lib64` and not just `lib` on some platforms.
* [Allow x.y.z.1 to use x.y.z C++ library](https://github.com/apache/arrow/pull/36435/commits/a77f909830c89846fd5119de56c536a333e4f44b), so that apt/yum official release packages can be used with patched versions submitted to CRAN.

### Are these changes tested?

The version check change has a unit test. The LIB_DIR change hopefully is well enough covered by our existing CI.

* Closes: #35710

Authored-by: Neal Richardson <neal.p.richardson@gmail.com>
Signed-off-by: Sutou Kouhei <kou@clear-code.com>