Elon Musk has said his iconic Cybertruck will end its run after a controversial and problem-filled three years on the market.