GH-30036: [C++] Timezone-aware kernels should handle offset strings (e.g. "+04:30")

GH-30036: [C++] Timezone-aware kernels should handle offset strings (e.g. "+04:30") #2238