The correct answer is situational irony.
Explanation: Situational irony occurs when there is a discrepancy between what is expected to happen and what actually happens. In this sentence, John claims to be "amazing" at creating a toothpick sculpture, yet the sculpture has fallen apart, which contradicts his assertion of skill. This contrast between his confidence and the outcome creates a situation that is ironic.