Hello there,
If you would like to see one of the best examples of this kind of thing happening in real life and causing mass destruction, do a quick search for the
Tacoma Narrows Bridge
that went into resonant oscillation back in 1940. High winds caused it to start swaying back and forth and twisting and turning, and that's concrete and steel, and eventually it just couldnt take it anymore and broke up and fell into the water below. A structure like this constitutes a system or order higher than 1, and that kind of system is capable of resonance if the damping is too low.
However, that's only works for systems that have an under damped response, and the damping coefficient determines that so only systems with a certain maximum damping coefficient will go into resonance like that. That means not every system will do this, so not every structure will do this.
The way this works is that with a small amount of energy input at the right times the total energy of the system builds up over time. This happens because when the damping coefficient is low the energy released does not equal the energy put into the system so there is some net energy left when the next input interval comes along. That puts even more energy into the system and so the oscillation grows. Now some systems can still crash even with higher damping, but that takes much more energy so it isnt nearly as likely.
The conclusion then is that you can collapse some structures with a small amount of energy if you know it's resonate point, but other structures would take much more force so they are more stable and wont fall down unless a huge amount of force is applied such as an earth quake or bulldozer. Still yet other structures would fall with less energy than some direct force like an earthquake, but the energy needed is still larger than is normally seen by the structure. So we can sort of class these structures into three types: Those that require small amounts of energy applied at the right times, those that require more energy applied at the right times, and those that require a large amount of energy and the time isnt as important.
The point of application on the object could be a factor too, as some points may be more sensitive than others. This would be due to a nonlinear damping along dimensions in the directions of x, y, and/or z.
There are some buildings that actually have active damping. That means a huge mass inside the building is made to move using mechanical actuators (like motors) in accordance with a control law for the building such that it sways less with a disturbance such as wind. The mass moves to minimize the movement of the building in the plane of x and y. This keeps it much more stable, so a building like that would be impossible to topple with a small amount of energy unless the designers made a mistake and you know what that mistake is and take advantage of it.