US President Donald Trump has predicted 2018 will be a "tremendous year" after bidding farewell to 2017 with a lavish party at his private club in Florida.