That cue was used in some fashion in every Bond film through LALD. And it's my personal favorite as well.
Ah yes, the legendary "007" theme. Not to be confused with the "James Bond Theme". 007 has been used in 5 Bond movies. From Russia With Love Thunderball You Only Live Twice Diamonds Are Forever and Moonraker. I do home it returns one day but EoN will have to get the rights from the late John Barry's estate before it will be used again.