GH-44629: [C++][Acero] Use implicit_ordering for asof_join rather than require_sequenced_output

GH-44629: [C++][Acero] Use implicit_ordering for asof_join rather than require_sequenced_output #19564