A rock star’s Wiltshire open garden was one of the “busiest ever” as crowds visited his multi-million-pound car collection.