sql: utilize reverse scans when useful for ORDER BY

[petermattis]

When an ORDER BY clause requests descending ordering, evaluate whether a reverse scan would be beneficial. The evaluation itself should be straightforward. The larger bit of worker is adding support for reverse scans to scanNode.