Support SETTINGS in CREATE TABLE with implicit ENGINE and mixed settings

Support SETTINGS in a CREATE TABLE query with an implicit ENGINE and support mixing engine and query settings. #73120 (Raúl Marín).