ENG-4676: eliminate OrderBy plan node for JOIN + ORDER BY when ordering ...

...by indexed columns; push down LIMIT node for JOIN node with sort direction.